| Key Name |
Key Type |
Keys |
| SaAutoBillBatchDetail_SyCampusID_AutoBillType_Amount_AdEnrollID_AdFeesID_SaBillCodeId_N_N_IDX |
Inversion Entry |
CampusId, BillingType, Amount |
| SaAutoBillBatchDetail_SyCampusID_AutoBillType_N_N_IDX |
Inversion Entry |
CampusId, BillingType |
| SaAutoBillBatchDetail_UserID_N_N_IDX |
Inversion Entry |
LastModifiedUserId |
| SaAutoBillBatchDetail_SaBillCodeID_N_N_IDX |
Inversion Entry |
BillingTransactionCodeId |
| SaAutoBillBatchDetail_AdTermID_N_N_IDX |
Inversion Entry |
TermId |
| SaAutoBillBatchDetail_AdFeesID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodFeeId |
| SaAutoBillBatchDetail_SaAutoBillBatchDetailID_U_C_IDX |
PrimaryKey |
AutomaticBillingBatchDetailId |
| SaAutoBillBatchDetail_AdEnrollLessonID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId |
| SaAutoBillBatchDetail_SyCampusID_SaBillingMethodID_SaAutoBillBatchDetailID_U_N_IDX |
Alternate Key |
CampusId, BillingMethodId, StudentEnrollmentPeriodId |
| SaAutoBillBatchDetail_AdEnrollID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| BillingMethod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BillingMethodId |
NO |
| BillingTransactionCode |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BillingTransactionCodeId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CampusId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
One To Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| StudentEnrollmentPeriodLesson |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodLessonId |
NO |
| StudentEnrollmentPeriodFee |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodFeeId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |
| BillingTransactionCode |
Non-Identifying |
One To Zero or More |
|
|
|
BillingTransactionCodeId |
NO |
| BillingMethod |
Non-Identifying |
One To Zero or More |
|
|
|
BillingMethodId |
NO |
| Campus |
Non-Identifying |
One To Zero or More |
|
|
|
CampusId |
NO |
| Staff |
Non-Identifying |
One To Zero or More |
|
|
|
LastModifiedUserId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| StudentEnrollmentPeriodFee |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodFeeId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |